<?php

define('APP_ROOT', dirname(dirname(__FILE__)));
require_once APP_ROOT . '/system/init.php';
//require_once APP_ROOT . '/scripts/_confirm.php';
    
$conn = Doctrine_Manager::connection();
    
$conn->execute('DROP SCHEMA IF EXISTS person CASCADE');
$conn->execute('CREATE SCHEMA person');
    
$conn->execute('DROP SCHEMA IF EXISTS public CASCADE');
$conn->execute('CREATE SCHEMA public');
    
Doctrine::createTablesFromArray(array(
    'User',
    'Group',
    'UserGroup',
    'Article',
    'Category',
    'Picture'
));
